Dataset statistics
| Number of variables | 36 |
|---|---|
| Number of observations | 122694 |
| Missing cells | 989398 |
| Missing cells (%) | 22.4% |
| Total size in memory | 30.4 MiB |
| Average record size in memory | 260.0 B |
Variable types
| Text | 22 |
|---|---|
| Numeric | 8 |
| Boolean | 4 |
| Unsupported | 2 |
site_id has constant value "" | Constant |
promotions has constant value "" | Constant |
shipping_store_pick_up has constant value "" | Constant |
installments_rate has constant value "" | Constant |
installments_currency_id has constant value "" | Constant |
accepts_mercadopago is highly imbalanced (57.8%) | Imbalance |
condition has 2512 (2.0%) missing values | Missing |
catalog_product_id has 72249 (58.9%) missing values | Missing |
price has 1233 (1.0%) missing values | Missing |
original_price has 94174 (76.8%) missing values | Missing |
official_store_id has 107396 (87.5%) missing values | Missing |
official_store_name has 107442 (87.6%) missing values | Missing |
shipping_logistic_type has 10083 (8.2%) missing values | Missing |
shipping_benefits has 122694 (100.0%) missing values | Missing |
shipping_promise has 122694 (100.0%) missing values | Missing |
installments_quantity has 26197 (21.4%) missing values | Missing |
installments_amount has 26197 (21.4%) missing values | Missing |
installments_rate has 26197 (21.4%) missing values | Missing |
installments_currency_id has 26197 (21.4%) missing values | Missing |
brand_value_name has 19767 (16.1%) missing values | Missing |
location has 112183 (91.4%) missing values | Missing |
seller_contact has 112183 (91.4%) missing values | Missing |
price is highly skewed (γ1 = 21.66230264) | Skewed |
original_price is highly skewed (γ1 = 36.80616502) | Skewed |
available_quantity is highly skewed (γ1 = 34.46965695) | Skewed |
installments_amount is highly skewed (γ1 = 26.51384463) | Skewed |
shipping_benefits is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
shipping_promise is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
installments_rate has 96497 (78.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-25 01:31:00.259338 |
|---|---|
| Analysis finished | 2024-02-25 01:31:10.090439 |
| Duration | 9.83 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
id
Text
| Distinct | 115871 |
|---|---|
| Distinct (%) | 94.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 12.64947756 |
| Min length | 12 |
Characters and Unicode
| Total characters | 1552015 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 109054 ? |
|---|---|
| Unique (%) | 88.9% |
Sample
| 1st row | MCO1324022622 |
|---|---|
| 2nd row | MCO1271613775 |
| 3rd row | MCO1037658202 |
| 4th row | MCO1343307899 |
| 5th row | MCO1318891937 |
| Value | Count | Frequency (%) |
| mco1321892971 | 3 | < 0.1% |
| mco1326134609 | 3 | < 0.1% |
| mco1620188094 | 3 | < 0.1% |
| mco1149899347 | 3 | < 0.1% |
| mco1092024925 | 3 | < 0.1% |
| mco1303888682 | 3 | < 0.1% |
| mco1339099263 | 2 | < 0.1% |
| mco585366257 | 2 | < 0.1% |
| mco2012965406 | 2 | < 0.1% |
| mco1213397504 | 2 | < 0.1% |
| Other values (115861) | 122668 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 171665 | |
| 2 | 126272 | |
| 3 | 126070 | |
| M | 122694 | 7.9% |
| C | 122694 | 7.9% |
| O | 122694 | 7.9% |
| 8 | 114092 | 7.4% |
| 5 | 113388 | 7.3% |
| 9 | 111385 | 7.2% |
| 6 | 109386 | 7.0% |
| Other values (3) | 311675 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1183933 | |
| Uppercase Letter | 368082 | 23.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 171665 | |
| 2 | 126272 | |
| 3 | 126070 | |
| 8 | 114092 | |
| 5 | 113388 | |
| 9 | 111385 | |
| 6 | 109386 | |
| 0 | 107719 | |
| 4 | 102841 | |
| 7 | 101115 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1183933 | |
| Latin | 368082 | 23.7% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 171665 | |
| 2 | 126272 | |
| 3 | 126070 | |
| 8 | 114092 | |
| 5 | 113388 | |
| 9 | 111385 | |
| 6 | 109386 | |
| 0 | 107719 | |
| 4 | 102841 | |
| 7 | 101115 |
Latin
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1552015 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 171665 | |
| 2 | 126272 | |
| 3 | 126070 | |
| M | 122694 | 7.9% |
| C | 122694 | 7.9% |
| O | 122694 | 7.9% |
| 8 | 114092 | 7.4% |
| 5 | 113388 | 7.3% |
| 9 | 111385 | 7.2% |
| 6 | 109386 | 7.0% |
| Other values (3) | 311675 |
title
Text
| Distinct | 110244 |
|---|---|
| Distinct (%) | 89.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 200 |
|---|---|
| Median length | 190 |
| Mean length | 52.32759548 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6420282 |
|---|---|
| Distinct characters | 148 |
| Distinct categories | 17 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 99738 ? |
|---|---|
| Unique (%) | 81.3% |
Sample
| 1st row | Pila Recargables Aa X2 Energizer 2000 Mah |
|---|---|
| 2nd row | Pila Energizer Recharge Universal Aaa X 4und |
| 3rd row | Audífonos In-ear Inalámbricos Bluetooth F9-5 Negro |
| 4th row | Televisor 43 Pulgadas Smart Android Ref. 43lo69 |
| 5th row | Parlante Jbl Flip 6 Portátil Con Bluetooth Waterproof Roja 110v/220v |
| Value | Count | Frequency (%) |
| de | 43603 | 4.2% |
| 28884 | 2.8% | |
| para | 18987 | 1.8% |
| en | 10973 | 1.1% |
| color | 10959 | 1.1% |
| a | 10517 | 1.0% |
| con | 8778 | 0.8% |
| y | 8540 | 0.8% |
| x | 7738 | 0.7% |
| negro | 6766 | 0.7% |
| Other values (75968) | 878283 |
Most occurring characters
| Value | Count | Frequency (%) |
| 937583 | 14.6% | |
| a | 564580 | 8.8% |
| o | 449897 | 7.0% |
| e | 433113 | 6.7% |
| r | 363625 | 5.7% |
| i | 321974 | 5.0% |
| l | 268125 | 4.2% |
| n | 254151 | 4.0% |
| t | 236136 | 3.7% |
| s | 217370 | 3.4% |
| Other values (138) | 2373728 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4150324 | |
| Space Separator | 938276 | 14.6% |
| Uppercase Letter | 883908 | 13.8% |
| Decimal Number | 338293 | 5.3% |
| Other Punctuation | 53056 | 0.8% |
| Dash Punctuation | 30811 | 0.5% |
| Math Symbol | 9650 | 0.2% |
| Currency Symbol | 7384 | 0.1% |
| Open Punctuation | 3779 | 0.1% |
| Close Punctuation | 3531 | 0.1% |
| Other values (7) | 1270 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 564580 | |
| o | 449897 | |
| e | 433113 | |
| r | 363625 | |
| i | 321974 | 7.8% |
| l | 268125 | 6.5% |
| n | 254151 | 6.1% |
| t | 236136 | 5.7% |
| s | 217370 | 5.2% |
| c | 151742 | 3.7% |
| Other values (41) | 889611 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 103820 | 11.7% |
| P | 91103 | 10.3% |
| D | 76773 | 8.7% |
| M | 60003 | 6.8% |
| A | 60001 | 6.8% |
| S | 53267 | 6.0% |
| E | 50105 | 5.7% |
| B | 44933 | 5.1% |
| T | 40092 | 4.5% |
| L | 39483 | 4.5% |
| Other values (27) | 264328 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 18834 | |
| . | 16096 | |
| / | 10380 | |
| : | 1674 | 3.2% |
| ' | 1400 | 2.6% |
| % | 1153 | 2.2% |
| ! | 1036 | 2.0% |
| & | 853 | 1.6% |
| * | 623 | 1.2% |
| # | 487 | 0.9% |
| Other values (7) | 520 | 1.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82795 | |
| 1 | 60365 | |
| 2 | 50322 | |
| 5 | 32435 | 9.6% |
| 3 | 26951 | 8.0% |
| 4 | 23971 | 7.1% |
| 6 | 19229 | 5.7% |
| 8 | 15949 | 4.7% |
| 7 | 13355 | 3.9% |
| 9 | 12921 | 3.8% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 9034 | |
| | | 517 | 5.4% |
| × | 39 | 0.4% |
| = | 35 | 0.4% |
| ~ | 16 | 0.2% |
| ± | 8 | 0.1% |
| ÷ | 1 | < 0.1% |
Other Number
| Value | Count | Frequency (%) |
| ³ | 31 | |
| ½ | 22 | |
| ² | 20 | |
| ¼ | 11 | 13.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3532 | |
| [ | 243 | 6.4% |
| { | 4 | 0.1% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3305 | |
| ] | 221 | 6.3% |
| } | 5 | 0.1% |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 448 | |
| ° | 306 | |
| © | 8 | 1.0% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 219 | |
| ¨ | 9 | 3.8% |
| ` | 7 | 3.0% |
Space Separator
| Value | Count | Frequency (%) |
| 937583 | ||
| 693 | 0.1% |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 7383 | |
| £ | 1 | < 0.1% |
Other Letter
| Value | Count | Frequency (%) |
| ª | 75 | |
| º | 61 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30811 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 45 |
Final Punctuation
| Value | Count | Frequency (%) |
| » | 5 |
Format
| Value | Count | Frequency (%) |
| | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5034367 | |
| Common | 1385915 | 21.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 564580 | 11.2% |
| o | 449897 | 8.9% |
| e | 433113 | 8.6% |
| r | 363625 | 7.2% |
| i | 321974 | 6.4% |
| l | 268125 | 5.3% |
| n | 254151 | 5.0% |
| t | 236136 | 4.7% |
| s | 217370 | 4.3% |
| c | 151742 | 3.0% |
| Other values (79) | 1773654 |
Common
| Value | Count | Frequency (%) |
| 937583 | ||
| 0 | 82795 | 6.0% |
| 1 | 60365 | 4.4% |
| 2 | 50322 | 3.6% |
| 5 | 32435 | 2.3% |
| - | 30811 | 2.2% |
| 3 | 26951 | 1.9% |
| 4 | 23971 | 1.7% |
| 6 | 19229 | 1.4% |
| , | 18834 | 1.4% |
| Other values (49) | 102619 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6360220 | |
| None | 60062 | 0.9% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 937583 | ||
| a | 564580 | 8.9% |
| o | 449897 | 7.1% |
| e | 433113 | 6.8% |
| r | 363625 | 5.7% |
| i | 321974 | 5.1% |
| l | 268125 | 4.2% |
| n | 254151 | 4.0% |
| t | 236136 | 3.7% |
| s | 217370 | 3.4% |
| Other values (81) | 2313666 |
None
| Value | Count | Frequency (%) |
| ó | 13904 | |
| á | 12892 | |
| ñ | 11288 | |
| í | 9744 | |
| é | 6775 | |
| ú | 1627 | 2.7% |
| 693 | 1.2% | |
| Á | 639 | 1.1% |
| ® | 448 | 0.7% |
| ° | 306 | 0.5% |
| Other values (47) | 1746 | 2.9% |
condition
Text
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2512 |
| Missing (%) | 2.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 3.08547037 |
| Min length | 3 |
Characters and Unicode
| Total characters | 370818 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | new |
|---|---|
| 2nd row | new |
| 3rd row | new |
| 4th row | new |
| 5th row | new |
| Value | Count | Frequency (%) |
| new | 110396 | |
| used | 9732 | 8.1% |
| not_specified | 54 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 120236 | |
| n | 110450 | |
| w | 110396 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| _ | 54 | < 0.1% |
| Other values (3) | 162 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 370764 | |
| Connector Punctuation | 54 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 120236 | |
| n | 110450 | |
| w | 110396 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| p | 54 | < 0.1% |
| Other values (2) | 108 | < 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 54 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 370764 | |
| Common | 54 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 120236 | |
| n | 110450 | |
| w | 110396 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| p | 54 | < 0.1% |
| Other values (2) | 108 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| _ | 54 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 370818 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 120236 | |
| n | 110450 | |
| w | 110396 | |
| s | 9786 | 2.6% |
| d | 9786 | 2.6% |
| u | 9732 | 2.6% |
| i | 108 | < 0.1% |
| o | 54 | < 0.1% |
| t | 54 | < 0.1% |
| _ | 54 | < 0.1% |
| Other values (3) | 162 | < 0.1% |
MISSING 
| Distinct | 41327 |
|---|---|
| Distinct (%) | 81.9% |
| Missing | 72249 |
| Missing (%) | 58.9% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 10.96986817 |
| Min length | 9 |
Characters and Unicode
| Total characters | 553375 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 34624 ? |
|---|---|
| Unique (%) | 68.6% |
Sample
| 1st row | MCO21850181 |
|---|---|
| 2nd row | MCO22015422 |
| 3rd row | MCO16224063 |
| 4th row | MCO26796977 |
| 5th row | MCO18930465 |
| Value | Count | Frequency (%) |
| mco18951365 | 20 | < 0.1% |
| mco6107994 | 20 | < 0.1% |
| mco16268158 | 17 | < 0.1% |
| mco19681518 | 17 | < 0.1% |
| mco22238606 | 16 | < 0.1% |
| mco21777210 | 16 | < 0.1% |
| mco18706965 | 15 | < 0.1% |
| mco8755482 | 15 | < 0.1% |
| mco27216699 | 15 | < 0.1% |
| mco6454377 | 15 | < 0.1% |
| Other values (41317) | 50279 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| M | 50445 | |
| C | 50445 | |
| O | 50445 | |
| 1 | 48306 | |
| 7 | 37907 | 6.9% |
| 9 | 36461 | 6.6% |
| 0 | 36259 | 6.6% |
| 5 | 36133 | 6.5% |
| 3 | 35525 | 6.4% |
| Other values (3) | 102593 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 402040 | |
| Uppercase Letter | 151335 | 27.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| 1 | 48306 | |
| 7 | 37907 | |
| 9 | 36461 | |
| 0 | 36259 | |
| 5 | 36133 | |
| 3 | 35525 | |
| 4 | 34374 | |
| 8 | 34197 | |
| 6 | 34022 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 50445 | |
| C | 50445 | |
| O | 50445 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 402040 | |
| Latin | 151335 | 27.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| 1 | 48306 | |
| 7 | 37907 | |
| 9 | 36461 | |
| 0 | 36259 | |
| 5 | 36133 | |
| 3 | 35525 | |
| 4 | 34374 | |
| 8 | 34197 | |
| 6 | 34022 |
Latin
| Value | Count | Frequency (%) |
| M | 50445 | |
| C | 50445 | |
| O | 50445 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 553375 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 68856 | |
| M | 50445 | |
| C | 50445 | |
| O | 50445 | |
| 1 | 48306 | |
| 7 | 37907 | 6.9% |
| 9 | 36461 | 6.6% |
| 0 | 36259 | 6.6% |
| 5 | 36133 | 6.5% |
| 3 | 35525 | 6.4% |
| Other values (3) | 102593 |
listing_type_id
Text
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 10.64477481 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1306050 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | gold_special |
|---|---|
| 2nd row | gold_special |
| 3rd row | gold_special |
| 4th row | gold_pro |
| 5th row | gold_special |
| Value | Count | Frequency (%) |
| gold_special | 74864 | |
| gold_pro | 37313 | |
| gold_premium | 8359 | 6.8% |
| free | 1939 | 1.6% |
| gold | 100 | 0.1% |
| bronze | 82 | 0.1% |
| silver | 37 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 195537 | |
| o | 158031 | |
| g | 120636 | |
| d | 120636 | |
| _ | 120536 | |
| p | 120536 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 5.7% |
| c | 74864 | 5.7% |
| Other values (9) | 149893 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1185514 | |
| Connector Punctuation | 120536 | 9.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 195537 | |
| o | 158031 | |
| g | 120636 | |
| d | 120636 | |
| p | 120536 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 6.3% |
| c | 74864 | 6.3% |
| a | 74864 | 6.3% |
| Other values (8) | 75029 | 6.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 120536 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1185514 | |
| Common | 120536 | 9.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 195537 | |
| o | 158031 | |
| g | 120636 | |
| d | 120636 | |
| p | 120536 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 6.3% |
| c | 74864 | 6.3% |
| a | 74864 | 6.3% |
| Other values (8) | 75029 | 6.3% |
Common
| Value | Count | Frequency (%) |
| _ | 120536 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1306050 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 195537 | |
| o | 158031 | |
| g | 120636 | |
| d | 120636 | |
| _ | 120536 | |
| p | 120536 | |
| e | 87220 | |
| i | 83260 | |
| s | 74901 | 5.7% |
| c | 74864 | 5.7% |
| Other values (9) | 149893 |
permalink
Text
| Distinct | 115272 |
|---|---|
| Distinct (%) | 94.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 361 |
|---|---|
| Median length | 320 |
| Mean length | 103.4475606 |
| Min length | 47 |
Characters and Unicode
| Total characters | 12692395 |
|---|---|
| Distinct characters | 45 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 108040 ? |
|---|---|
| Unique (%) | 88.1% |
Sample
| 1st row | https://www.mercadolibre.com.co/pila-recargables-aa-x2-energizer-2000-mah/p/MCO21850181 |
|---|---|
| 2nd row | https://www.mercadolibre.com.co/pila-energizer-recharge-universal-aaa-x-4und/p/MCO22015422 |
| 3rd row | https://www.mercadolibre.com.co/audifonos-in-ear-inalambricos-bluetooth-f9-5-negro/p/MCO16224063 |
| 4th row | https://www.mercadolibre.com.co/televisor-43-pulgadas-smart-android-ref-43lo69/p/MCO26796977 |
| 5th row | https://www.mercadolibre.com.co/parlante-jbl-flip-6-portatil-con-bluetooth-waterproof-roja-110v220v/p/MCO18930465 |
| Value | Count | Frequency (%) |
| https://www.mercadolibre.com.co/microfono-hyperx-quadcast-condensador-bidireccional-color-negro/p/mco15160609 | 5 | < 0.1% |
| https://www.mercadolibre.com.co/boya-by-v1-negro/p/mco23076703 | 5 | < 0.1% |
| https://www.mercadolibre.com.co/silla-escritorio-ejecutiva-ergonomica-reclinable-oficina-pc-color-negro-material-del-tapizado-malla/p/mco26042278 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-gamer-hyperx-duocast-black-hmid1r-a-bkg/p/mco19747373 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/audifonos-logitech-h390-diadema-color-negro/p/mco6417063 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-trust-primo-21674-condensador-omnidireccional-color-negro/p/mco17944890 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-fifine-k669-condensador-cardioide-color-negro/p/mco17469532 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-hyperx-blx-solocast-condensador-cardioide-color-negro/p/mco17481564 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-sf-666-condensador-omnidireccional-color-negro/p/mco15161567 | 4 | < 0.1% |
| https://www.mercadolibre.com.co/microfono-razer-seiren-seiren-mini-condensador-supercardioide-color-blanco-mercurio/p/mco16650278 | 4 | < 0.1% |
| Other values (115262) | 122652 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 1137795 | 9.0% |
| o | 934521 | 7.4% |
| a | 844246 | 6.7% |
| e | 745872 | 5.9% |
| r | 730807 | 5.8% |
| c | 706886 | 5.6% |
| t | 602814 | 4.7% |
| i | 554667 | 4.4% |
| l | 507008 | 4.0% |
| / | 443182 | 3.5% |
| Other values (35) | 5484597 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 8566793 | |
| Decimal Number | 1430335 | 11.3% |
| Dash Punctuation | 1137795 | 9.0% |
| Other Punctuation | 933958 | 7.4% |
| Uppercase Letter | 538370 | 4.2% |
| Connector Punctuation | 85144 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 934521 | |
| a | 844246 | 9.9% |
| e | 745872 | 8.7% |
| r | 730807 | 8.5% |
| c | 706886 | 8.3% |
| t | 602814 | 7.0% |
| i | 554667 | 6.5% |
| l | 507008 | 5.9% |
| m | 415860 | 4.9% |
| s | 399239 | 4.7% |
| Other values (16) | 2124873 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 202889 | |
| 2 | 186371 | |
| 0 | 179261 | |
| 5 | 141198 | |
| 3 | 134047 | |
| 6 | 121589 | |
| 8 | 121031 | |
| 4 | 119978 | |
| 9 | 116441 | |
| 7 | 107530 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 207838 | |
| C | 122694 | |
| O | 122694 | |
| J | 85144 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 443182 | |
| . | 368082 | |
| : | 122694 | 13.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1137795 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 85144 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 9105163 | |
| Common | 3587232 | 28.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 934521 | 10.3% |
| a | 844246 | 9.3% |
| e | 745872 | 8.2% |
| r | 730807 | 8.0% |
| c | 706886 | 7.8% |
| t | 602814 | 6.6% |
| i | 554667 | 6.1% |
| l | 507008 | 5.6% |
| m | 415860 | 4.6% |
| s | 399239 | 4.4% |
| Other values (20) | 2663243 |
Common
| Value | Count | Frequency (%) |
| - | 1137795 | |
| / | 443182 | 12.4% |
| . | 368082 | 10.3% |
| 1 | 202889 | 5.7% |
| 2 | 186371 | 5.2% |
| 0 | 179261 | 5.0% |
| 5 | 141198 | 3.9% |
| 3 | 134047 | 3.7% |
| : | 122694 | 3.4% |
| 6 | 121589 | 3.4% |
| Other values (5) | 550124 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12692395 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 1137795 | 9.0% |
| o | 934521 | 7.4% |
| a | 844246 | 6.7% |
| e | 745872 | 5.9% |
| r | 730807 | 5.8% |
| c | 706886 | 5.6% |
| t | 602814 | 4.7% |
| i | 554667 | 4.4% |
| l | 507008 | 4.0% |
| / | 443182 | 3.5% |
| Other values (35) | 5484597 |
buying_mode
Text
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1226940 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | buy_it_now |
|---|---|
| 2nd row | buy_it_now |
| 3rd row | buy_it_now |
| 4th row | buy_it_now |
| 5th row | buy_it_now |
| Value | Count | Frequency (%) |
| buy_it_now | 112183 | |
| classified | 10511 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 224366 | |
| i | 133205 | |
| b | 112183 | |
| u | 112183 | |
| y | 112183 | |
| t | 112183 | |
| n | 112183 | |
| o | 112183 | |
| w | 112183 | |
| s | 21022 | 1.7% |
| Other values (6) | 63066 | 5.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1002574 | |
| Connector Punctuation | 224366 | 18.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 133205 | |
| b | 112183 | |
| u | 112183 | |
| y | 112183 | |
| t | 112183 | |
| n | 112183 | |
| o | 112183 | |
| w | 112183 | |
| s | 21022 | 2.1% |
| c | 10511 | 1.0% |
| Other values (5) | 52555 | 5.2% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 224366 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1002574 | |
| Common | 224366 | 18.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 133205 | |
| b | 112183 | |
| u | 112183 | |
| y | 112183 | |
| t | 112183 | |
| n | 112183 | |
| o | 112183 | |
| w | 112183 | |
| s | 21022 | 2.1% |
| c | 10511 | 1.0% |
| Other values (5) | 52555 | 5.2% |
Common
| Value | Count | Frequency (%) |
| _ | 224366 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1226940 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 224366 | |
| i | 133205 | |
| b | 112183 | |
| u | 112183 | |
| y | 112183 | |
| t | 112183 | |
| n | 112183 | |
| o | 112183 | |
| w | 112183 | |
| s | 21022 | 1.7% |
| Other values (6) | 63066 | 5.1% |
site_id
Text
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 368082 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MCO |
|---|---|
| 2nd row | MCO |
| 3rd row | MCO |
| 4th row | MCO |
| 5th row | MCO |
| Value | Count | Frequency (%) |
| mco | 122694 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 368082 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 368082 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 368082 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
category_id
Text
| Distinct | 3776 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.247404111 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1011907 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 691 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | MCO7279 |
|---|---|
| 2nd row | MCO7279 |
| 3rd row | MCO3697 |
| 4th row | MCO14903 |
| 5th row | MCO3691 |
| Value | Count | Frequency (%) |
| mco1196 | 3998 | 3.3% |
| mco1744 | 3686 | 3.0% |
| mco1176 | 3185 | 2.6% |
| mco8830 | 2063 | 1.7% |
| mco1442 | 1784 | 1.5% |
| mco9355 | 1404 | 1.1% |
| mco1474 | 1334 | 1.1% |
| mco435877 | 1222 | 1.0% |
| mco167011 | 1135 | 0.9% |
| mco9356 | 1132 | 0.9% |
| Other values (3766) | 101751 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 134793 | |
| M | 122694 | |
| C | 122694 | |
| O | 122694 | |
| 4 | 85845 | |
| 7 | 67315 | |
| 6 | 64412 | |
| 3 | 61716 | |
| 8 | 47186 | 4.7% |
| 9 | 45895 | 4.5% |
| Other values (3) | 136663 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 643825 | |
| Uppercase Letter | 368082 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 134793 | |
| 4 | 85845 | |
| 7 | 67315 | |
| 6 | 64412 | |
| 3 | 61716 | |
| 8 | 47186 | 7.3% |
| 9 | 45895 | 7.1% |
| 5 | 45799 | 7.1% |
| 0 | 45586 | 7.1% |
| 2 | 45278 | 7.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 643825 | |
| Latin | 368082 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 134793 | |
| 4 | 85845 | |
| 7 | 67315 | |
| 6 | 64412 | |
| 3 | 61716 | |
| 8 | 47186 | 7.3% |
| 9 | 45895 | 7.1% |
| 5 | 45799 | 7.1% |
| 0 | 45586 | 7.1% |
| 2 | 45278 | 7.0% |
Latin
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1011907 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 134793 | |
| M | 122694 | |
| C | 122694 | |
| O | 122694 | |
| 4 | 85845 | |
| 7 | 67315 | |
| 6 | 64412 | |
| 3 | 61716 | |
| 8 | 47186 | 4.7% |
| 9 | 45895 | 4.5% |
| Other values (3) | 136663 |
domain_id
Text
| Distinct | 2746 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 58 |
|---|---|
| Median length | 47 |
| Mean length | 20.0546074 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2460580 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 409 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | MCO-CELL_BATTERIES |
|---|---|
| 2nd row | MCO-CELL_BATTERIES |
| 3rd row | MCO-HEADPHONES |
| 4th row | MCO-TELEVISIONS |
| 5th row | MCO-SPEAKERS |
| Value | Count | Frequency (%) |
| mco-books | 3998 | 3.3% |
| mco-cars_and_vans | 3686 | 3.0% |
| mco-music_albums | 3185 | 2.6% |
| mco-headphones | 2151 | 1.8% |
| mco-supplements | 2127 | 1.7% |
| mco-cats_and_dogs_foods | 1887 | 1.5% |
| mco-wristwatches | 1784 | 1.5% |
| mco-coins | 1404 | 1.1% |
| mco-individual_apartments_for_sale | 1334 | 1.1% |
| mco-balloons | 1222 | 1.0% |
| Other values (2736) | 99916 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 239471 | 9.7% |
| C | 227623 | 9.3% |
| S | 216410 | 8.8% |
| E | 190696 | 7.8% |
| M | 177240 | 7.2% |
| A | 164935 | 6.7% |
| _ | 163312 | 6.6% |
| R | 127161 | 5.2% |
| - | 122694 | 5.0% |
| I | 115750 | 4.7% |
| Other values (20) | 715288 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2174511 | |
| Connector Punctuation | 163312 | 6.6% |
| Dash Punctuation | 122694 | 5.0% |
| Decimal Number | 63 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 239471 | |
| C | 227623 | |
| S | 216410 | |
| E | 190696 | 8.8% |
| M | 177240 | 8.2% |
| A | 164935 | 7.6% |
| R | 127161 | 5.8% |
| I | 115750 | 5.3% |
| T | 111595 | 5.1% |
| N | 102156 | 4.7% |
| Other values (16) | 501474 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 60 | |
| 2 | 3 | 4.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 163312 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2174511 | |
| Common | 286069 | 11.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| O | 239471 | |
| C | 227623 | |
| S | 216410 | |
| E | 190696 | 8.8% |
| M | 177240 | 8.2% |
| A | 164935 | 7.6% |
| R | 127161 | 5.8% |
| I | 115750 | 5.3% |
| T | 111595 | 5.1% |
| N | 102156 | 4.7% |
| Other values (16) | 501474 |
Common
| Value | Count | Frequency (%) |
| _ | 163312 | |
| - | 122694 | |
| 3 | 60 | < 0.1% |
| 2 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2460580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| O | 239471 | 9.7% |
| C | 227623 | 9.3% |
| S | 216410 | 8.8% |
| E | 190696 | 7.8% |
| M | 177240 | 7.2% |
| A | 164935 | 6.7% |
| _ | 163312 | 6.6% |
| R | 127161 | 5.2% |
| - | 122694 | 5.0% |
| I | 115750 | 4.7% |
| Other values (20) | 715288 |
price
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 27612 |
|---|---|
| Distinct (%) | 22.7% |
| Missing | 1233 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22944636.07 |
| Minimum | 1400 |
|---|---|
| Maximum | 9999999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 1400 |
|---|---|
| 5-th percentile | 11500 |
| Q1 | 32900 |
| median | 81500 |
| Q3 | 238860 |
| 95-th percentile | 41000000 |
| Maximum | 9999999999 |
| Range | 9999998599 |
| Interquartile range (IQR) | 205960 |
Descriptive statistics
| Standard deviation | 213319501.1 |
|---|---|
| Coefficient of variation (CV) | 9.297140319 |
| Kurtosis | 662.9554081 |
| Mean | 22944636.07 |
| Median Absolute Deviation (MAD) | 60500 |
| Skewness | 21.66230264 |
| Sum | 2.786878442 × 1012 |
| Variance | 4.550520955 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90000 | 985 | 0.8% |
| 39900 | 706 | 0.6% |
| 19900 | 676 | 0.6% |
| 29900 | 673 | 0.5% |
| 60000 | 614 | 0.5% |
| 70000 | 610 | 0.5% |
| 49900 | 609 | 0.5% |
| 50000 | 599 | 0.5% |
| 59900 | 543 | 0.4% |
| 35000 | 531 | 0.4% |
| Other values (27602) | 114915 | |
| (Missing) | 1233 | 1.0% |
| Value | Count | Frequency (%) |
| 1400 | 5 | < 0.1% |
| 1500 | 2 | < 0.1% |
| 2000 | 7 | < 0.1% |
| 2500 | 3 | < 0.1% |
| 2900 | 52 |
| Value | Count | Frequency (%) |
| 9999999999 | 5 | |
| 9999000000 | 1 | < 0.1% |
| 9350000000 | 1 | < 0.1% |
| 9000000000 | 1 | < 0.1% |
| 8700000000 | 1 | < 0.1% |
original_price
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 7620 |
|---|---|
| Distinct (%) | 26.7% |
| Missing | 94174 |
| Missing (%) | 76.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 472765.2113 |
| Minimum | 3145 |
|---|---|
| Maximum | 319900000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 3145 |
|---|---|
| 5-th percentile | 14900 |
| Q1 | 39512 |
| median | 98900 |
| Q3 | 259900 |
| 95-th percentile | 1599900 |
| Maximum | 319900000 |
| Range | 319896855 |
| Interquartile range (IQR) | 220388 |
Descriptive statistics
| Standard deviation | 4351787.258 |
|---|---|
| Coefficient of variation (CV) | 9.204965073 |
| Kurtosis | 1722.660718 |
| Mean | 472765.2113 |
| Median Absolute Deviation (MAD) | 71901 |
| Skewness | 36.80616502 |
| Sum | 1.348326383 × 1010 |
| Variance | 1.893805234 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 29900 | 250 | 0.2% |
| 49900 | 242 | 0.2% |
| 59900 | 232 | 0.2% |
| 89900 | 226 | 0.2% |
| 39900 | 224 | 0.2% |
| 69900 | 222 | 0.2% |
| 99900 | 222 | 0.2% |
| 19900 | 210 | 0.2% |
| 79900 | 184 | 0.1% |
| 199900 | 180 | 0.1% |
| Other values (7610) | 26328 | 21.5% |
| (Missing) | 94174 |
| Value | Count | Frequency (%) |
| 3145 | 2 | |
| 3200 | 1 | |
| 3225 | 1 | |
| 3239 | 1 | |
| 3500 | 1 |
| Value | Count | Frequency (%) |
| 319900000 | 1 | < 0.1% |
| 178990000 | 1 | < 0.1% |
| 144990000 | 6 | |
| 144900000 | 1 | < 0.1% |
| 142900000 | 1 | < 0.1% |
available_quantity
Real number (ℝ)
SKEWED 
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 98.92498411 |
| Minimum | 1 |
|---|---|
| Maximum | 50000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 250 |
| Maximum | 50000 |
| Range | 49999 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1354.370107 |
|---|---|
| Coefficient of variation (CV) | 13.69088021 |
| Kurtosis | 1259.556767 |
| Mean | 98.92498411 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.46965695 |
| Sum | 12137502 |
| Variance | 1834318.388 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 95652 | |
| 50 | 11619 | 9.5% |
| 500 | 5437 | 4.4% |
| 250 | 3147 | 2.6% |
| 150 | 2635 | 2.1% |
| 100 | 2572 | 2.1% |
| 200 | 966 | 0.8% |
| 5000 | 582 | 0.5% |
| 50000 | 84 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 95652 | |
| 50 | 11619 | 9.5% |
| 100 | 2572 | 2.1% |
| 150 | 2635 | 2.1% |
| 200 | 966 | 0.8% |
| Value | Count | Frequency (%) |
| 50000 | 84 | 0.1% |
| 5000 | 582 | 0.5% |
| 500 | 5437 | |
| 250 | 3147 | |
| 200 | 966 | 0.8% |
official_store_id
Real number (ℝ)
MISSING 
| Distinct | 551 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 107396 |
| Missing (%) | 87.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4671.14394 |
| Minimum | 2 |
|---|---|
| Maximum | 65680 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 153 |
| Q1 | 608 |
| median | 1278 |
| Q3 | 1960 |
| 95-th percentile | 50047 |
| Maximum | 65680 |
| Range | 65678 |
| Interquartile range (IQR) | 1352 |
Descriptive statistics
| Standard deviation | 13241.22539 |
|---|---|
| Coefficient of variation (CV) | 2.834685799 |
| Kurtosis | 10.63181263 |
| Mean | 4671.14394 |
| Median Absolute Deviation (MAD) | 680.5 |
| Skewness | 3.529640562 |
| Sum | 71459160 |
| Variance | 175330050 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1117 | 550 | 0.4% |
| 1278 | 459 | 0.4% |
| 1961 | 399 | 0.3% |
| 2059 | 395 | 0.3% |
| 2068 | 372 | 0.3% |
| 1287 | 366 | 0.3% |
| 663 | 278 | 0.2% |
| 344 | 272 | 0.2% |
| 467 | 239 | 0.2% |
| 535 | 229 | 0.2% |
| Other values (541) | 11739 | 9.6% |
| (Missing) | 107396 |
| Value | Count | Frequency (%) |
| 2 | 42 | < 0.1% |
| 4 | 28 | < 0.1% |
| 11 | 95 | |
| 22 | 114 | |
| 23 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 65680 | 10 | < 0.1% |
| 65522 | 6 | < 0.1% |
| 64348 | 2 | < 0.1% |
| 63262 | 4 | < 0.1% |
| 62882 | 46 |
MISSING 
| Distinct | 548 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 107442 |
| Missing (%) | 87.6% |
| Memory size | 958.7 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 26 |
| Mean length | 10.04301075 |
| Min length | 2 |
Characters and Unicode
| Total characters | 153176 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | Energizer |
|---|---|
| 2nd row | Energizer |
| 3rd row | Challenger |
| 4th row | JBL |
| 5th row | Sony |
| Value | Count | Frequency (%) |
| libreria | 842 | 3.8% |
| la | 759 | 3.4% |
| ferreteria | 586 | 2.6% |
| croydon | 550 | 2.5% |
| de | 489 | 2.2% |
| u | 459 | 2.0% |
| gm | 399 | 1.8% |
| comunicaciones | 399 | 1.8% |
| ipetplace | 395 | 1.8% |
| ebook | 372 | 1.7% |
| Other values (661) | 17175 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 13964 | 9.1% |
| a | 13094 | 8.5% |
| o | 12732 | 8.3% |
| r | 9990 | 6.5% |
| i | 8924 | 5.8% |
| 7305 | 4.8% | |
| l | 7064 | 4.6% |
| t | 6435 | 4.2% |
| s | 6265 | 4.1% |
| n | 6229 | 4.1% |
| Other values (50) | 61174 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 112653 | |
| Uppercase Letter | 32945 | 21.5% |
| Space Separator | 7305 | 4.8% |
| Decimal Number | 273 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 13964 | |
| a | 13094 | |
| o | 12732 | |
| r | 9990 | |
| i | 8924 | 7.9% |
| l | 7064 | 6.3% |
| t | 6435 | 5.7% |
| s | 6265 | 5.6% |
| n | 6229 | 5.5% |
| c | 5060 | 4.5% |
| Other values (16) | 22896 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 2742 | 8.3% |
| L | 2489 | 7.6% |
| C | 2472 | 7.5% |
| E | 2211 | 6.7% |
| A | 2188 | 6.6% |
| I | 1943 | 5.9% |
| B | 1853 | 5.6% |
| T | 1823 | 5.5% |
| O | 1822 | 5.5% |
| R | 1626 | 4.9% |
| Other values (16) | 11776 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 155 | |
| 1 | 75 | |
| 6 | 16 | 5.9% |
| 3 | 14 | 5.1% |
| 0 | 9 | 3.3% |
| 4 | 2 | 0.7% |
| 5 | 2 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 7305 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 145598 | |
| Common | 7578 | 4.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 13964 | 9.6% |
| a | 13094 | 9.0% |
| o | 12732 | 8.7% |
| r | 9990 | 6.9% |
| i | 8924 | 6.1% |
| l | 7064 | 4.9% |
| t | 6435 | 4.4% |
| s | 6265 | 4.3% |
| n | 6229 | 4.3% |
| c | 5060 | 3.5% |
| Other values (42) | 55841 |
Common
| Value | Count | Frequency (%) |
| 7305 | ||
| 2 | 155 | 2.0% |
| 1 | 75 | 1.0% |
| 6 | 16 | 0.2% |
| 3 | 14 | 0.2% |
| 0 | 9 | 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 153176 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 13964 | 9.1% |
| a | 13094 | 8.5% |
| o | 12732 | 8.3% |
| r | 9990 | 6.5% |
| i | 8924 | 5.8% |
| 7305 | 4.8% | |
| l | 7064 | 4.6% |
| t | 6435 | 4.2% |
| s | 6265 | 4.1% |
| n | 6229 | 4.1% |
| Other values (50) | 61174 |
accepts_mercadopago
Boolean
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| True | |
|---|---|
| False | 10511 |
| Value | Count | Frequency (%) |
| True | 112183 | |
| False | 10511 | 8.6% |
stop_time
Text
| Distinct | 20679 |
|---|---|
| Distinct (%) | 16.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 24 |
| Mean length | 24 |
| Min length | 24 |
Characters and Unicode
| Total characters | 2944656 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 16454 ? |
|---|---|
| Unique (%) | 13.4% |
Sample
| 1st row | 2043-03-12T04:00:00.000Z |
|---|---|
| 2nd row | 2044-02-03T14:32:39.000Z |
| 3rd row | 2042-10-29T04:00:00.000Z |
| 4th row | 2044-02-01T16:24:12.000Z |
| 5th row | 2043-07-20T04:00:00.000Z |
| Value | Count | Frequency (%) |
| 2043-08-17t04:00:00.000z | 421 | 0.3% |
| 2043-10-19t04:00:00.000z | 363 | 0.3% |
| 2043-07-19t04:00:00.000z | 358 | 0.3% |
| 2043-08-19t04:00:00.000z | 335 | 0.3% |
| 2043-08-03t04:00:00.000z | 329 | 0.3% |
| 2043-09-13t04:00:00.000z | 323 | 0.3% |
| 2043-08-23t04:00:00.000z | 318 | 0.3% |
| 2043-10-26t04:00:00.000z | 317 | 0.3% |
| 2043-07-22t04:00:00.000z | 316 | 0.3% |
| 2043-07-28t04:00:00.000z | 309 | 0.3% |
| Other values (20669) | 119305 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1161075 | |
| 4 | 265340 | 9.0% |
| - | 245388 | 8.3% |
| : | 245388 | 8.3% |
| 2 | 243861 | 8.3% |
| 1 | 149648 | 5.1% |
| T | 122694 | 4.2% |
| . | 122694 | 4.2% |
| Z | 122694 | 4.2% |
| 3 | 108077 | 3.7% |
| Other values (5) | 157797 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2085798 | |
| Other Punctuation | 368082 | 12.5% |
| Dash Punctuation | 245388 | 8.3% |
| Uppercase Letter | 245388 | 8.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1161075 | |
| 4 | 265340 | 12.7% |
| 2 | 243861 | 11.7% |
| 1 | 149648 | 7.2% |
| 3 | 108077 | 5.2% |
| 5 | 35818 | 1.7% |
| 8 | 31608 | 1.5% |
| 7 | 31521 | 1.5% |
| 9 | 31428 | 1.5% |
| 6 | 27422 | 1.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 245388 | |
| . | 122694 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 122694 | |
| Z | 122694 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 245388 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2699268 | |
| Latin | 245388 | 8.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1161075 | |
| 4 | 265340 | 9.8% |
| - | 245388 | 9.1% |
| : | 245388 | 9.1% |
| 2 | 243861 | 9.0% |
| 1 | 149648 | 5.5% |
| . | 122694 | 4.5% |
| 3 | 108077 | 4.0% |
| 5 | 35818 | 1.3% |
| 8 | 31608 | 1.2% |
| Other values (3) | 90371 | 3.3% |
Latin
| Value | Count | Frequency (%) |
| T | 122694 | |
| Z | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2944656 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1161075 | |
| 4 | 265340 | 9.0% |
| - | 245388 | 8.3% |
| : | 245388 | 8.3% |
| 2 | 243861 | 8.3% |
| 1 | 149648 | 5.1% |
| T | 122694 | 4.2% |
| . | 122694 | 4.2% |
| Z | 122694 | 4.2% |
| 3 | 108077 | 3.7% |
| Other values (5) | 157797 | 5.4% |
catalog_listing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 85144 | |
| True | 37550 |
promotions
Text
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 245388 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | [] |
|---|---|
| 2nd row | [] |
| 3rd row | [] |
| 4th row | [] |
| 5th row | [] |
| Value | Count | Frequency (%) |
| 122694 |
Most occurring characters
| Value | Count | Frequency (%) |
| [ | 122694 | |
| ] | 122694 |
Most occurring categories
| Value | Count | Frequency (%) |
| Open Punctuation | 122694 | |
| Close Punctuation | 122694 |
Most frequent character per category
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 122694 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 245388 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| [ | 122694 | |
| ] | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 245388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| [ | 122694 | |
| ] | 122694 |
category
Text
| Distinct | 32 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.328418668 |
| Min length | 7 |
Characters and Unicode
| Total characters | 899153 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MCO1000 |
|---|---|
| 2nd row | MCO1000 |
| 3rd row | MCO1000 |
| 4th row | MCO1000 |
| 5th row | MCO1000 |
| Value | Count | Frequency (%) |
| mco1368 | 4000 | 3.3% |
| mco1367 | 4000 | 3.3% |
| mco1743 | 4000 | 3.3% |
| mco1430 | 4000 | 3.3% |
| mco1168 | 4000 | 3.3% |
| mco118204 | 4000 | 3.3% |
| mco1403 | 4000 | 3.3% |
| mco175794 | 4000 | 3.3% |
| mco1276 | 4000 | 3.3% |
| mco180800 | 3999 | 3.3% |
| Other values (22) | 82695 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 142370 | |
| M | 122694 | |
| C | 122694 | |
| O | 122694 | |
| 4 | 67044 | |
| 0 | 58769 | |
| 7 | 51944 | 5.8% |
| 3 | 48598 | 5.4% |
| 8 | 35980 | 4.0% |
| 9 | 35963 | 4.0% |
| Other values (3) | 90403 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 531071 | |
| Uppercase Letter | 368082 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 142370 | |
| 4 | 67044 | |
| 0 | 58769 | |
| 7 | 51944 | 9.8% |
| 3 | 48598 | 9.2% |
| 8 | 35980 | 6.8% |
| 9 | 35963 | 6.8% |
| 2 | 31979 | 6.0% |
| 5 | 30446 | 5.7% |
| 6 | 27978 | 5.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 531071 | |
| Latin | 368082 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 142370 | |
| 4 | 67044 | |
| 0 | 58769 | |
| 7 | 51944 | 9.8% |
| 3 | 48598 | 9.2% |
| 8 | 35980 | 6.8% |
| 9 | 35963 | 6.8% |
| 2 | 31979 | 6.0% |
| 5 | 30446 | 5.7% |
| 6 | 27978 | 5.3% |
Latin
| Value | Count | Frequency (%) |
| M | 122694 | |
| C | 122694 | |
| O | 122694 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 899153 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 142370 | |
| M | 122694 | |
| C | 122694 | |
| O | 122694 | |
| 4 | 67044 | |
| 0 | 58769 | |
| 7 | 51944 | 5.8% |
| 3 | 48598 | 5.4% |
| 8 | 35980 | 4.0% |
| 9 | 35963 | 4.0% |
| Other values (3) | 90403 |
shipping_store_pick_up
Boolean
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False |
|---|
| Value | Count | Frequency (%) |
| False | 122694 |
shipping_free_shipping
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 70954 | |
| True | 51740 |
MISSING 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10083 |
| Missing (%) | 8.2% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 11.45898713 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1290408 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | fulfillment |
|---|---|
| 2nd row | fulfillment |
| 3rd row | cross_docking |
| 4th row | cross_docking |
| 5th row | fulfillment |
| Value | Count | Frequency (%) |
| xd_drop_off | 45607 | |
| cross_docking | 38287 | |
| fulfillment | 15212 | 13.5% |
| drop_off | 9411 | 8.4% |
| not_specified | 3389 | 3.0% |
| custom | 612 | 0.5% |
| default | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 190611 | |
| f | 143942 | |
| d | 142394 | |
| _ | 142301 | |
| r | 93305 | 7.2% |
| c | 80575 | 6.2% |
| s | 80575 | 6.2% |
| i | 60277 | 4.7% |
| p | 58407 | 4.5% |
| n | 56888 | 4.4% |
| Other values (9) | 241133 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1148107 | |
| Connector Punctuation | 142301 | 11.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 190611 | |
| f | 143942 | |
| d | 142394 | |
| r | 93305 | |
| c | 80575 | |
| s | 80575 | |
| i | 60277 | 5.3% |
| p | 58407 | 5.1% |
| n | 56888 | 5.0% |
| l | 45729 | 4.0% |
| Other values (8) | 195404 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 142301 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1148107 | |
| Common | 142301 | 11.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 190611 | |
| f | 143942 | |
| d | 142394 | |
| r | 93305 | |
| c | 80575 | |
| s | 80575 | |
| i | 60277 | 5.3% |
| p | 58407 | 5.1% |
| n | 56888 | 5.0% |
| l | 45729 | 4.0% |
| Other values (8) | 195404 |
Common
| Value | Count | Frequency (%) |
| _ | 142301 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1290408 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 190611 | |
| f | 143942 | |
| d | 142394 | |
| _ | 142301 | |
| r | 93305 | 7.2% |
| c | 80575 | 6.2% |
| s | 80575 | 6.2% |
| i | 60277 | 4.7% |
| p | 58407 | 4.5% |
| n | 56888 | 4.4% |
| Other values (9) | 241133 |
shipping_mode
Text
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 4.11298026 |
| Min length | 3 |
Characters and Unicode
| Total characters | 504638 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | me2 |
|---|---|
| 2nd row | me2 |
| 3rd row | me2 |
| 4th row | me2 |
| 5th row | me2 |
| Value | Count | Frequency (%) |
| me2 | 108517 | |
| not_specified | 13472 | 11.0% |
| custom | 612 | 0.5% |
| me1 | 93 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 135554 | |
| m | 109222 | |
| 2 | 108517 | |
| i | 26944 | 5.3% |
| o | 14084 | 2.8% |
| t | 14084 | 2.8% |
| s | 14084 | 2.8% |
| c | 14084 | 2.8% |
| n | 13472 | 2.7% |
| _ | 13472 | 2.7% |
| Other values (5) | 41121 | 8.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 382556 | |
| Decimal Number | 108610 | 21.5% |
| Connector Punctuation | 13472 | 2.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 135554 | |
| m | 109222 | |
| i | 26944 | 7.0% |
| o | 14084 | 3.7% |
| t | 14084 | 3.7% |
| s | 14084 | 3.7% |
| c | 14084 | 3.7% |
| n | 13472 | 3.5% |
| p | 13472 | 3.5% |
| f | 13472 | 3.5% |
| Other values (2) | 14084 | 3.7% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 108517 | |
| 1 | 93 | 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 13472 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 382556 | |
| Common | 122082 | 24.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 135554 | |
| m | 109222 | |
| i | 26944 | 7.0% |
| o | 14084 | 3.7% |
| t | 14084 | 3.7% |
| s | 14084 | 3.7% |
| c | 14084 | 3.7% |
| n | 13472 | 3.5% |
| p | 13472 | 3.5% |
| f | 13472 | 3.5% |
| Other values (2) | 14084 | 3.7% |
Common
| Value | Count | Frequency (%) |
| 2 | 108517 | |
| _ | 13472 | 11.0% |
| 1 | 93 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 504638 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 135554 | |
| m | 109222 | |
| 2 | 108517 | |
| i | 26944 | 5.3% |
| o | 14084 | 2.8% |
| t | 14084 | 2.8% |
| s | 14084 | 2.8% |
| c | 14084 | 2.8% |
| n | 13472 | 2.7% |
| _ | 13472 | 2.7% |
| Other values (5) | 41121 | 8.1% |
shipping_tags
Text
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 135 |
|---|---|
| Median length | 132 |
| Mean length | 24.11475704 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2958736 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ['fulfillment', 'self_service_out'] |
|---|---|
| 2nd row | ['fulfillment', 'self_service_in'] |
| 3rd row | ['self_service_in'] |
| 4th row | ['mandatory_free_shipping', 'optional_me2_chosen'] |
| 5th row | ['fulfillment', 'self_service_in', 'mandatory_free_shipping'] |
| Value | Count | Frequency (%) |
| self_service_in | 54448 | |
| mandatory_free_shipping | 46987 | |
| 29448 | ||
| fulfillment | 15212 | 9.4% |
| self_service_out | 7682 | 4.8% |
| mco-chg-threshold-jan-23 | 3497 | 2.2% |
| fs_threshold_mco_change_apr2021 | 1182 | 0.7% |
| fs_threshold_mco_change_jul2021 | 1065 | 0.7% |
| fbm_in_process | 815 | 0.5% |
| is_flammable | 761 | 0.5% |
| Other values (8) | 447 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 306126 | 10.3% |
| ' | 264192 | 8.9% |
| _ | 230696 | 7.8% |
| i | 228109 | 7.7% |
| s | 182387 | 6.2% |
| n | 170924 | 5.8% |
| r | 163999 | 5.5% |
| f | 143447 | 4.8% |
| [ | 122694 | 4.1% |
| ] | 122694 | 4.1% |
| Other values (27) | 1023468 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2096443 | |
| Other Punctuation | 303042 | 10.2% |
| Connector Punctuation | 230696 | 7.8% |
| Open Punctuation | 122694 | 4.1% |
| Close Punctuation | 122694 | 4.1% |
| Space Separator | 38850 | 1.3% |
| Decimal Number | 16341 | 0.6% |
| Dash Punctuation | 13988 | 0.5% |
| Uppercase Letter | 13988 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 306126 | |
| i | 228109 | |
| s | 182387 | 8.7% |
| n | 170924 | 8.2% |
| r | 163999 | 7.8% |
| f | 143447 | 6.8% |
| l | 116702 | 5.6% |
| a | 103113 | 4.9% |
| p | 96228 | 4.6% |
| t | 75994 | 3.6% |
| Other values (12) | 509414 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 8320 | |
| 3 | 3497 | |
| 1 | 2277 | 13.9% |
| 0 | 2247 | 13.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 3497 | |
| C | 3497 | |
| O | 3497 | |
| J | 3497 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 264192 | |
| , | 38850 | 12.8% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 230696 |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 122694 |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 122694 |
Space Separator
| Value | Count | Frequency (%) |
| 38850 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13988 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2110431 | |
| Common | 848305 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 306126 | |
| i | 228109 | |
| s | 182387 | 8.6% |
| n | 170924 | 8.1% |
| r | 163999 | 7.8% |
| f | 143447 | 6.8% |
| l | 116702 | 5.5% |
| a | 103113 | 4.9% |
| p | 96228 | 4.6% |
| t | 75994 | 3.6% |
| Other values (16) | 523402 |
Common
| Value | Count | Frequency (%) |
| ' | 264192 | |
| _ | 230696 | |
| [ | 122694 | |
| ] | 122694 | |
| , | 38850 | 4.6% |
| 38850 | 4.6% | |
| - | 13988 | 1.6% |
| 2 | 8320 | 1.0% |
| 3 | 3497 | 0.4% |
| 1 | 2277 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2958736 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 306126 | 10.3% |
| ' | 264192 | 8.9% |
| _ | 230696 | 7.8% |
| i | 228109 | 7.7% |
| s | 182387 | 6.2% |
| n | 170924 | 5.8% |
| r | 163999 | 5.5% |
| f | 143447 | 4.8% |
| [ | 122694 | 4.1% |
| ] | 122694 | 4.1% |
| Other values (27) | 1023468 |
shipping_benefits
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 122694 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 958.7 KiB |
shipping_promise
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 122694 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 958.7 KiB |
seller_id
Real number (ℝ)
| Distinct | 15024 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 461490403 |
| Minimum | 17434 |
|---|---|
| Maximum | 1699297072 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 17434 |
|---|---|
| 5-th percentile | 39773006.3 |
| Q1 | 160820235 |
| median | 311862503 |
| Q3 | 637614324 |
| 95-th percentile | 1357110642 |
| Maximum | 1699297072 |
| Range | 1699279638 |
| Interquartile range (IQR) | 476794089 |
Descriptive statistics
| Standard deviation | 409865390.3 |
|---|---|
| Coefficient of variation (CV) | 0.8881341575 |
| Kurtosis | 0.644099614 |
| Mean | 461490403 |
| Median Absolute Deviation (MAD) | 207755224 |
| Skewness | 1.219153028 |
| Sum | 5.662210351 × 1013 |
| Variance | 1.679896381 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 181939816 | 1094 | 0.9% |
| 791273252 | 885 | 0.7% |
| 1194088518 | 848 | 0.7% |
| 394380898 | 662 | 0.5% |
| 91086457 | 605 | 0.5% |
| 313600420 | 551 | 0.4% |
| 573609394 | 490 | 0.4% |
| 178562922 | 473 | 0.4% |
| 279263455 | 459 | 0.4% |
| 438128163 | 426 | 0.3% |
| Other values (15014) | 116201 |
| Value | Count | Frequency (%) |
| 17434 | 24 | |
| 51545 | 1 | < 0.1% |
| 79421 | 1 | < 0.1% |
| 83777 | 1 | < 0.1% |
| 86705 | 25 |
| Value | Count | Frequency (%) |
| 1699297072 | 1 | |
| 1699214406 | 1 | |
| 1699209680 | 1 | |
| 1699183850 | 1 | |
| 1699177230 | 1 |
seller_nickname
Text
| Distinct | 15024 |
|---|---|
| Distinct (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 958.7 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 15.16379774 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1860507 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 8146 ? |
|---|---|
| Unique (%) | 6.6% |
Sample
| 1st row | OPERADOR TO |
|---|---|
| 2nd row | OPERADOR TO |
| 3rd row | JUAN20220131132107 |
| 4th row | CHALLENGER S.A.S. |
| 5th row | IXCOMERCIO COLOMBIA |
| Value | Count | Frequency (%) |
| sas | 3316 | 2.0% |
| colombia | 2147 | 1.3% |
| s.a.s | 1618 | 1.0% |
| store | 1475 | 0.9% |
| tienda | 1386 | 0.8% |
| hitmusical | 1094 | 0.7% |
| discotienda | 1094 | 0.7% |
| online | 917 | 0.6% |
| liberimportacinsasliberimp | 885 | 0.5% |
| gruporespaldoinmobiliariosa | 848 | 0.5% |
| Other values (15950) | 148732 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 179896 | 9.7% |
| O | 169360 | 9.1% |
| E | 152388 | 8.2% |
| I | 140463 | 7.5% |
| S | 122277 | 6.6% |
| R | 113705 | 6.1% |
| C | 100192 | 5.4% |
| L | 90427 | 4.9% |
| T | 88788 | 4.8% |
| N | 87958 | 4.7% |
| Other values (40) | 615053 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1653420 | |
| Decimal Number | 131199 | 7.1% |
| Space Separator | 40819 | 2.2% |
| Other Punctuation | 17634 | 0.9% |
| Connector Punctuation | 11982 | 0.6% |
| Dash Punctuation | 5453 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 179896 | |
| O | 169360 | |
| E | 152388 | 9.2% |
| I | 140463 | 8.5% |
| S | 122277 | 7.4% |
| R | 113705 | 6.9% |
| C | 100192 | 6.1% |
| L | 90427 | 5.5% |
| T | 88788 | 5.4% |
| N | 87958 | 5.3% |
| Other values (23) | 407966 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 27312 | |
| 0 | 21523 | |
| 1 | 19542 | |
| 3 | 12211 | |
| 4 | 9614 | 7.3% |
| 5 | 9364 | 7.1% |
| 9 | 8367 | 6.4% |
| 7 | 8012 | 6.1% |
| 6 | 7877 | 6.0% |
| 8 | 7377 | 5.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 17626 | |
| * | 6 | < 0.1% |
| : | 1 | < 0.1% |
| @ | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 40819 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 11982 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5453 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1653420 | |
| Common | 207087 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 179896 | |
| O | 169360 | |
| E | 152388 | 9.2% |
| I | 140463 | 8.5% |
| S | 122277 | 7.4% |
| R | 113705 | 6.9% |
| C | 100192 | 6.1% |
| L | 90427 | 5.5% |
| T | 88788 | 5.4% |
| N | 87958 | 5.3% |
| Other values (23) | 407966 |
Common
| Value | Count | Frequency (%) |
| 40819 | ||
| 2 | 27312 | |
| 0 | 21523 | |
| 1 | 19542 | |
| . | 17626 | |
| 3 | 12211 | 5.9% |
| _ | 11982 | 5.8% |
| 4 | 9614 | 4.6% |
| 5 | 9364 | 4.5% |
| 9 | 8367 | 4.0% |
| Other values (7) | 28727 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1859006 | |
| None | 1501 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 179896 | 9.7% |
| O | 169360 | 9.1% |
| E | 152388 | 8.2% |
| I | 140463 | 7.6% |
| S | 122277 | 6.6% |
| R | 113705 | 6.1% |
| C | 100192 | 5.4% |
| L | 90427 | 4.9% |
| T | 88788 | 4.8% |
| N | 87958 | 4.7% |
| Other values (33) | 613552 |
None
| Value | Count | Frequency (%) |
| Í | 461 | |
| Ñ | 282 | |
| Ó | 281 | |
| Á | 232 | |
| É | 189 | |
| Ú | 52 | 3.5% |
| Ü | 4 | 0.3% |
installments_quantity
Real number (ℝ)
MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26197 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.22251469 |
| Minimum | 12 |
|---|---|
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 36 |
| Q3 | 36 |
| 95-th percentile | 36 |
| Maximum | 36 |
| Range | 24 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 11.23261667 |
|---|---|
| Coefficient of variation (CV) | 0.3980019779 |
| Kurtosis | -1.434756459 |
| Mean | 28.22251469 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.751846579 |
| Sum | 2723388 |
| Variance | 126.1716772 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 36 | 65226 | |
| 12 | 31271 | |
| (Missing) | 26197 |
| Value | Count | Frequency (%) |
| 12 | 31271 | |
| 36 | 65226 |
| Value | Count | Frequency (%) |
| 36 | 65226 | |
| 12 | 31271 |
installments_amount
Real number (ℝ)
MISSING  SKEWED 
| Distinct | 25952 |
|---|---|
| Distinct (%) | 26.9% |
| Missing | 26197 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13664.68919 |
| Minimum | 546.81 |
|---|---|
| Maximum | 4086158.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 546.81 |
|---|---|
| 5-th percentile | 732.86 |
| Q1 | 1815.42 |
| median | 3747.22 |
| Q3 | 8886.11 |
| 95-th percentile | 48283.336 |
| Maximum | 4086158.33 |
| Range | 4085611.52 |
| Interquartile range (IQR) | 7070.69 |
Descriptive statistics
| Standard deviation | 61229.52166 |
|---|---|
| Coefficient of variation (CV) | 4.480857254 |
| Kurtosis | 1099.128579 |
| Mean | 13664.68919 |
| Median Absolute Deviation (MAD) | 2466.66 |
| Skewness | 26.51384463 |
| Sum | 1318601512 |
| Variance | 3749054323 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2500 | 771 | 0.6% |
| 4166.67 | 474 | 0.4% |
| 1666.67 | 462 | 0.4% |
| 5000 | 442 | 0.4% |
| 1108.33 | 430 | 0.4% |
| 7500 | 408 | 0.3% |
| 5833.33 | 382 | 0.3% |
| 1386.11 | 375 | 0.3% |
| 2083.33 | 374 | 0.3% |
| 552.78 | 367 | 0.3% |
| Other values (25942) | 92012 | |
| (Missing) | 26197 | 21.4% |
| Value | Count | Frequency (%) |
| 546.81 | 1 | < 0.1% |
| 546.94 | 2 | < 0.1% |
| 547.19 | 2 | < 0.1% |
| 547.22 | 20 | |
| 547.42 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4086158.33 | 1 | |
| 3583333.33 | 1 | |
| 3453241.67 | 1 | |
| 3333333.33 | 1 | |
| 2962575 | 1 |
installments_rate
Real number (ℝ)
CONSTANT  MISSING  ZEROS 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26197 |
| Missing (%) | 21.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0 |
| Minimum | 0 |
|---|---|
| Maximum | 0 |
| Zeros | 96497 |
| Zeros (%) | 78.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 958.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0 |
| Range | 0 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0 |
|---|---|
| Coefficient of variation (CV) | nan |
| Kurtosis | 0 |
| Mean | 0 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0 |
| Sum | 0 |
| Variance | 0 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 0 | 96497 | |
| (Missing) | 26197 | 21.4% |
| Value | Count | Frequency (%) |
| 0 | 96497 |
| Value | Count | Frequency (%) |
| 0 | 96497 |
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 26197 |
| Missing (%) | 21.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 289491 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COP |
|---|---|
| 2nd row | COP |
| 3rd row | COP |
| 4th row | COP |
| 5th row | COP |
| Value | Count | Frequency (%) |
| cop | 96497 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 96497 | |
| O | 96497 | |
| P | 96497 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 289491 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 96497 | |
| O | 96497 | |
| P | 96497 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 289491 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 96497 | |
| O | 96497 | |
| P | 96497 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 289491 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 96497 | |
| O | 96497 | |
| P | 96497 |
brand_value_name
Text
MISSING 
| Distinct | 19762 |
|---|---|
| Distinct (%) | 19.2% |
| Missing | 19767 |
| Missing (%) | 16.1% |
| Memory size | 958.7 KiB |
Length
| Max length | 214 |
|---|---|
| Median length | 200 |
| Mean length | 8.579264916 |
| Min length | 1 |
Characters and Unicode
| Total characters | 883038 |
|---|---|
| Distinct characters | 125 |
| Distinct categories | 16 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 4 ? |
Unique
| Unique | 11330 ? |
|---|---|
| Unique (%) | 11.0% |
Sample
| 1st row | Energizer |
|---|---|
| 2nd row | Energizer |
| 3rd row | Shenzhen Yihaotong |
| 4th row | Challenger |
| 5th row | JBL |
| Value | Count | Frequency (%) |
| genérica | 10636 | 7.7% |
| truper | 1057 | 0.8% |
| de | 1044 | 0.8% |
| casio | 757 | 0.6% |
| 653 | 0.5% | |
| sony | 631 | 0.5% |
| samsung | 623 | 0.5% |
| nintendo | 601 | 0.4% |
| la | 566 | 0.4% |
| home | 535 | 0.4% |
| Other values (18028) | 120443 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 72034 | 8.2% |
| a | 71810 | 8.1% |
| i | 57886 | 6.6% |
| o | 54973 | 6.2% |
| r | 54834 | 6.2% |
| n | 49993 | 5.7% |
| 34765 | 3.9% | |
| l | 34331 | 3.9% |
| t | 32871 | 3.7% |
| c | 31132 | 3.5% |
| Other values (115) | 388409 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 629774 | |
| Uppercase Letter | 207288 | 23.5% |
| Space Separator | 34771 | 3.9% |
| Other Punctuation | 4105 | 0.5% |
| Decimal Number | 4085 | 0.5% |
| Dash Punctuation | 2143 | 0.2% |
| Math Symbol | 309 | < 0.1% |
| Connector Punctuation | 250 | < 0.1% |
| Modifier Symbol | 152 | < 0.1% |
| Final Punctuation | 50 | < 0.1% |
| Other values (6) | 111 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 72034 | |
| a | 71810 | |
| i | 57886 | |
| o | 54973 | 8.7% |
| r | 54834 | 8.7% |
| n | 49993 | 7.9% |
| l | 34331 | 5.5% |
| t | 32871 | 5.2% |
| c | 31132 | 4.9% |
| s | 30331 | 4.8% |
| Other values (37) | 139579 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 17379 | 8.4% |
| S | 15593 | 7.5% |
| A | 14583 | 7.0% |
| C | 13197 | 6.4% |
| M | 12784 | 6.2% |
| E | 12226 | 5.9% |
| T | 12151 | 5.9% |
| P | 10561 | 5.1% |
| L | 9656 | 4.7% |
| O | 9647 | 4.7% |
| Other values (25) | 79511 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1299 | |
| ' | 971 | |
| & | 841 | |
| , | 610 | |
| / | 151 | 3.7% |
| : | 92 | 2.2% |
| % | 64 | 1.6% |
| ! | 50 | 1.2% |
| * | 14 | 0.3% |
| # | 5 | 0.1% |
| Other values (3) | 8 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1016 | |
| 1 | 697 | |
| 3 | 597 | |
| 2 | 513 | |
| 4 | 311 | 7.6% |
| 5 | 265 | 6.5% |
| 6 | 249 | 6.1% |
| 8 | 184 | 4.5% |
| 7 | 164 | 4.0% |
| 9 | 89 | 2.2% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 307 | |
| ± | 1 | 0.3% |
| > | 1 | 0.3% |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 12 | |
| ° | 4 | 22.2% |
| ™ | 2 | 11.1% |
Space Separator
| Value | Count | Frequency (%) |
| 34765 | ||
| 6 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2142 | |
| – | 1 | < 0.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ´ | 150 | |
| ` | 2 | 1.3% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 43 | |
| [ | 1 | 2.3% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 250 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 50 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 43 |
Other Letter
| Value | Count | Frequency (%) |
| º | 4 |
Other Number
| Value | Count | Frequency (%) |
| ² | 1 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 837066 | |
| Common | 45972 | 5.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 72034 | 8.6% |
| a | 71810 | 8.6% |
| i | 57886 | 6.9% |
| o | 54973 | 6.6% |
| r | 54834 | 6.6% |
| n | 49993 | 6.0% |
| l | 34331 | 4.1% |
| t | 32871 | 3.9% |
| c | 31132 | 3.7% |
| s | 30331 | 3.6% |
| Other values (73) | 346871 |
Common
| Value | Count | Frequency (%) |
| 34765 | ||
| - | 2142 | 4.7% |
| . | 1299 | 2.8% |
| 0 | 1016 | 2.2% |
| ' | 971 | 2.1% |
| & | 841 | 1.8% |
| 1 | 697 | 1.5% |
| , | 610 | 1.3% |
| 3 | 597 | 1.3% |
| 2 | 513 | 1.1% |
| Other values (32) | 2521 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 868878 | |
| None | 14107 | 1.6% |
| Punctuation | 51 | < 0.1% |
| Letterlike Symbols | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 72034 | 8.3% |
| a | 71810 | 8.3% |
| i | 57886 | 6.7% |
| o | 54973 | 6.3% |
| r | 54834 | 6.3% |
| n | 49993 | 5.8% |
| 34765 | 4.0% | |
| l | 34331 | 4.0% |
| t | 32871 | 3.8% |
| c | 31132 | 3.6% |
| Other values (75) | 374249 |
None
| Value | Count | Frequency (%) |
| é | 11248 | |
| í | 704 | 5.0% |
| ó | 682 | 4.8% |
| ñ | 315 | 2.2% |
| á | 277 | 2.0% |
| ä | 214 | 1.5% |
| ú | 153 | 1.1% |
| ´ | 150 | 1.1% |
| Ñ | 77 | 0.5% |
| ü | 30 | 0.2% |
| Other values (27) | 257 | 1.8% |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 50 | |
| – | 1 | 2.0% |
Letterlike Symbols
| Value | Count | Frequency (%) |
| ™ | 2 |
location
Text
MISSING 
| Distinct | 6566 |
|---|---|
| Distinct (%) | 62.5% |
| Missing | 112183 |
| Missing (%) | 91.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 514 |
|---|---|
| Median length | 414 |
| Mean length | 338.5627438 |
| Min length | 234 |
Characters and Unicode
| Total characters | 3558633 |
|---|---|
| Distinct characters | 95 |
| Distinct categories | 13 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 5786 ? |
|---|---|
| Unique (%) | 55.0% |
Sample
| 1st row | {'address_line': 'Cl. 181a #7-28, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQlNBTjkyNDYy', 'name': 'San Antonio Norte'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7583128, 'longitude': -74.0261957} |
|---|---|
| 2nd row | {'address_line': 'Calle 145a #13a-90, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkNFRDEzNzQw', 'name': 'Cedritos'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7268959, 'longitude': -74.0401792} |
| 3rd row | {'address_line': 'Cl. 175 #15-20, Bogotá, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkxBNzE0ODc', 'name': 'La Alameda'}, 'city': {'id': 'TUNPQ1VTQTY3MTQ1', 'name': 'Usaquén'}, 'state': {'id': 'TUNPUEJPR1gxMDljZA', 'name': 'Bogotá D.C.'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 4.7553061, 'longitude': -74.0373278} |
| 4th row | {'address_line': 'Transversal 5d, El Poblado, Medellín, Antioquia, Colombia', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {'id': 'TUNPQkVMUDI3MDA0Ng', 'name': 'El Poblado'}, 'city': {'id': 'TUNPQ01FRGRjNjc4', 'name': 'Medellín'}, 'state': {'id': 'TUNPUEFOVGFiZWI3', 'name': 'Antioquia'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 6.2058014, 'longitude': -75.5697919} |
| 5th row | {'address_line': 'Sur', 'zip_code': '', 'subneighborhood': None, 'neighborhood': {}, 'city': {'id': 'TUNPQ0NBTDYyZDA0', 'name': 'Cali'}, 'state': {'id': 'TUNPUFZBTGExNmNjNg', 'name': 'Valle Del Cauca'}, 'country': {'id': 'CO', 'name': 'Colombia'}, 'latitude': 3.3704066, 'longitude': -76.5053344} |
| Value | Count | Frequency (%) |
| name | 39420 | 11.7% |
| id | 39420 | 11.7% |
| 18884 | 5.6% | |
| colombia | 12736 | 3.8% |
| country | 10569 | 3.1% |
| city | 10512 | 3.1% |
| co | 10511 | 3.1% |
| state | 10511 | 3.1% |
| address_line | 10511 | 3.1% |
| neighborhood | 10511 | 3.1% |
| Other values (17446) | 163607 |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 542986 | 15.3% |
| 327103 | 9.2% | |
| : | 171632 | 4.8% |
| o | 157739 | 4.4% |
| e | 154582 | 4.3% |
| i | 148529 | 4.2% |
| a | 129429 | 3.6% |
| , | 127736 | 3.6% |
| n | 123396 | 3.5% |
| d | 122275 | 3.4% |
| Other values (85) | 1553226 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1527120 | |
| Other Punctuation | 874091 | |
| Uppercase Letter | 469105 | 13.2% |
| Space Separator | 327103 | 9.2% |
| Decimal Number | 222630 | 6.3% |
| Open Punctuation | 52644 | 1.5% |
| Close Punctuation | 52644 | 1.5% |
| Connector Punctuation | 21029 | 0.6% |
| Dash Punctuation | 12126 | 0.3% |
| Math Symbol | 133 | < 0.1% |
| Other values (3) | 8 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 157739 | 10.3% |
| e | 154582 | 10.1% |
| i | 148529 | 9.7% |
| a | 129429 | 8.5% |
| n | 123396 | 8.1% |
| d | 122275 | 8.0% |
| t | 89032 | 5.8% |
| l | 72362 | 4.7% |
| m | 59752 | 3.9% |
| r | 59366 | 3.9% |
| Other values (23) | 410658 |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 59860 | |
| U | 49232 | 10.5% |
| T | 48165 | 10.3% |
| C | 37860 | 8.1% |
| P | 37317 | 8.0% |
| Q | 29500 | 6.3% |
| M | 19243 | 4.1% |
| O | 19051 | 4.1% |
| D | 18873 | 4.0% |
| E | 16819 | 3.6% |
| Other values (19) | 133185 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 542986 | |
| : | 171632 | 19.6% |
| , | 127736 | 14.6% |
| . | 29346 | 3.4% |
| # | 2312 | 0.3% |
| / | 52 | < 0.1% |
| & | 20 | < 0.1% |
| · | 3 | < 0.1% |
| \ | 2 | < 0.1% |
| ¿ | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 32775 | |
| 4 | 28179 | |
| 7 | 25015 | |
| 0 | 23839 | |
| 5 | 23660 | |
| 3 | 22665 | |
| 6 | 19875 | |
| 2 | 18668 | |
| 8 | 14066 | |
| 9 | 13888 |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 52555 | |
| ( | 89 | 0.2% |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 52555 | |
| ) | 89 | 0.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12122 | |
| – | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 327103 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 21029 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 133 |
Other Symbol
| Value | Count | Frequency (%) |
| ° | 4 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 3 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1996228 | |
| Common | 1562405 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 157739 | 7.9% |
| e | 154582 | 7.7% |
| i | 148529 | 7.4% |
| a | 129429 | 6.5% |
| n | 123396 | 6.2% |
| d | 122275 | 6.1% |
| t | 89032 | 4.5% |
| l | 72362 | 3.6% |
| N | 59860 | 3.0% |
| m | 59752 | 3.0% |
| Other values (53) | 879272 |
Common
| Value | Count | Frequency (%) |
| ' | 542986 | |
| 327103 | ||
| : | 171632 | 11.0% |
| , | 127736 | 8.2% |
| { | 52555 | 3.4% |
| } | 52555 | 3.4% |
| 1 | 32775 | 2.1% |
| . | 29346 | 1.9% |
| 4 | 28179 | 1.8% |
| 7 | 25015 | 1.6% |
| Other values (22) | 172523 | 11.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3546508 | |
| None | 12121 | 0.3% |
| Punctuation | 4 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 542986 | 15.3% |
| 327103 | 9.2% | |
| : | 171632 | 4.8% |
| o | 157739 | 4.4% |
| e | 154582 | 4.4% |
| i | 148529 | 4.2% |
| a | 129429 | 3.6% |
| , | 127736 | 3.6% |
| n | 123396 | 3.5% |
| d | 122275 | 3.4% |
| Other values (70) | 1541101 |
None
| Value | Count | Frequency (%) |
| á | 6393 | |
| í | 2733 | |
| é | 1662 | 13.7% |
| ó | 820 | 6.8% |
| ñ | 339 | 2.8% |
| ú | 120 | 1.0% |
| ü | 26 | 0.2% |
| Á | 13 | 0.1% |
| ° | 4 | < 0.1% |
| Ñ | 3 | < 0.1% |
| Other values (4) | 8 | 0.1% |
Punctuation
| Value | Count | Frequency (%) |
| – | 4 |
seller_contact
Text
MISSING 
| Distinct | 3490 |
|---|---|
| Distinct (%) | 33.2% |
| Missing | 112183 |
| Missing (%) | 91.4% |
| Memory size | 958.7 KiB |
Length
| Max length | 252 |
|---|---|
| Median length | 241 |
| Mean length | 133.2624869 |
| Min length | 123 |
Characters and Unicode
| Total characters | 1400722 |
|---|---|
| Distinct characters | 92 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 3145 ? |
|---|---|
| Unique (%) | 29.9% |
Sample
| 1st row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
|---|---|
| 2nd row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 3rd row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 4th row | {'contact': '', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| 5th row | {'contact': 'Red Inmobiliaria', 'other_info': '', 'webpage': '', 'area_code': '', 'phone': '', 'area_code2': '', 'phone2': '', 'email': ''} |
| Value | Count | Frequency (%) |
| 78018 | ||
| contact | 10513 | 5.9% |
| other_info | 10511 | 5.9% |
| webpage | 10511 | 5.9% |
| area_code | 10511 | 5.9% |
| phone | 10511 | 5.9% |
| area_code2 | 10511 | 5.9% |
| phone2 | 10511 | 5.9% |
| 10511 | 5.9% | |
| grupo | 972 | 0.5% |
| Other values (2197) | 13948 | 7.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| e | 108749 | 7.8% |
| : | 84108 | 6.0% |
| o | 80476 | 5.7% |
| a | 79635 | 5.7% |
| , | 73621 | 5.3% |
| n | 45092 | 3.2% |
| c | 42961 | 3.1% |
| r | 36203 | 2.6% |
| Other values (82) | 346849 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 616868 | |
| Other Punctuation | 495213 | |
| Space Separator | 166677 | 11.9% |
| Uppercase Letter | 46528 | 3.3% |
| Connector Punctuation | 31533 | 2.3% |
| Decimal Number | 22761 | 1.6% |
| Close Punctuation | 10515 | 0.8% |
| Open Punctuation | 10515 | 0.8% |
| Dash Punctuation | 110 | < 0.1% |
| Math Symbol | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 108749 | |
| o | 80476 | |
| a | 79635 | |
| n | 45092 | |
| c | 42961 | 7.0% |
| r | 36203 | 5.9% |
| p | 33733 | 5.5% |
| t | 32531 | 5.3% |
| h | 31711 | 5.1% |
| i | 26727 | 4.3% |
| Other values (23) | 99050 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 6353 | |
| I | 4842 | |
| R | 4741 | |
| O | 3711 | 8.0% |
| E | 3506 | 7.5% |
| S | 2849 | 6.1% |
| N | 2643 | 5.7% |
| L | 2444 | 5.3% |
| G | 2149 | 4.6% |
| M | 1804 | 3.9% |
| Other values (21) | 11486 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 336351 | |
| : | 84108 | 17.0% |
| , | 73621 | 14.9% |
| . | 995 | 0.2% |
| / | 57 | < 0.1% |
| & | 32 | < 0.1% |
| " | 30 | < 0.1% |
| # | 17 | < 0.1% |
| % | 1 | < 0.1% |
| @ | 1 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 21214 | |
| 3 | 290 | 1.3% |
| 4 | 238 | 1.0% |
| 1 | 228 | 1.0% |
| 0 | 175 | 0.8% |
| 8 | 159 | 0.7% |
| 5 | 138 | 0.6% |
| 9 | 124 | 0.5% |
| 6 | 109 | 0.5% |
| 7 | 86 | 0.4% |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 10511 | |
| ) | 4 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 10511 | |
| ( | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 166677 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 31533 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 110 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 737326 | |
| Latin | 663396 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 108749 | |
| o | 80476 | |
| a | 79635 | |
| n | 45092 | 6.8% |
| c | 42961 | 6.5% |
| r | 36203 | 5.5% |
| p | 33733 | 5.1% |
| t | 32531 | 4.9% |
| h | 31711 | 4.8% |
| i | 26727 | 4.0% |
| Other values (54) | 145578 |
Common
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| : | 84108 | 11.4% |
| , | 73621 | 10.0% |
| _ | 31533 | 4.3% |
| 2 | 21214 | 2.9% |
| } | 10511 | 1.4% |
| { | 10511 | 1.4% |
| . | 995 | 0.1% |
| 3 | 290 | < 0.1% |
| Other values (18) | 1515 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1400385 | |
| None | 337 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 336351 | |
| 166677 | ||
| e | 108749 | 7.8% |
| : | 84108 | 6.0% |
| o | 80476 | 5.7% |
| a | 79635 | 5.7% |
| , | 73621 | 5.3% |
| n | 45092 | 3.2% |
| c | 42961 | 3.1% |
| r | 36203 | 2.6% |
| Other values (70) | 346512 |
None
| Value | Count | Frequency (%) |
| Ñ | 75 | |
| ñ | 64 | |
| á | 46 | |
| í | 46 | |
| ó | 39 | |
| é | 24 | 7.1% |
| Ó | 13 | 3.9% |
| Í | 11 | 3.3% |
| Á | 9 | 2.7% |
| É | 5 | 1.5% |
| Other values (2) | 5 | 1.5% |